package com.bosch.in.rtp1.ept.constant;

public interface FinishRecipeConstant {
	
	// finished recipes table columns name
	String STAGE_DB				= "P2R_STAGE";
	String LOCATION_DB			= "P2R_LOCATION";
	String EQPTYPE_DB			= "P2R_EQP_TYPE";
	// x-factor detail columns name
	String FACTOR_LOT_ID		= "LOTID";
	String FACTOR_PART_ID		= "PARTID";
	String FACTOR_VALUE			= "VALUE";
	String FACTOR_TIME_REV		= "TIMEREV";
	String FACTOR_RECIPE		= "RECIPE";
	String FACTOR_HOLD_DUR		= "HOLD_DURATION";
	String FACTOR_HOLD_CODE		= "HOLD_CODE";
	String FACTOR_HOLD_COMT		= "HOLD_COMMENT";
	String FACTOR_RELEASE_COMT	= "RELEASE_COMMENT";
	String FACTOR_CUSTOMER_NAME = "CUSTOMER_NAME";
	String FACTOR_PROD_AREA		= "AREA";
	String FACTOR_LOCATION		= "LOCATION";
	String FACTOR_STAGE			= "STAGE";
	String FACTOR_EQPTYPE		= "EQPTYPE";
	
	// parameters name for communication between client-server
	String PART_ID_PARAM		= "partId";
	String LOCATION_PARAM		= "selectedLocation";
	String STAGE_PARAM			= "selectedStage";
	String EQUIPID_PARAM		= "equipId";
	String EQPTYPE_PARAM		= "selectedEqptype";
	String PRIORITY_PARAM		= "priority";
	String PRODAREA_PARAM		= "prodArea";
	String YEAR_PARAM			= "selectedYear";
	String CUSTOMER_PARAM		= "customerName";
	String PART_ID_PARAM_HIDDEN	= "hiddenPartId";
	String LOCATION_PARAM_HIDDEN= "hiddenLocation";
	String STAGE_PARAM_HIDDEN	= "hiddenStage";
	String EQUIPID_PARAM_HIDDEN	= "hiddenEquipId";
	String EQPTYPE_PARAM_HIDDEN = "hiddenEqptype";
	String YEAR_PARAM_HIDDEN 	= "hiddenYear";
	String CUSTOMER_PARAM_HIDDEN= "hiddenCustomerName";
	String FACTOR_TYPE_PARAM	= "type";
	String MONTH_PARAM			= "month";
	
	// FACTOR_TYPE
	int X_PLAN					= 0;
	int X_RW					= 1;
	int X_RWH					= 2;
	
	// list of available prod area, priority
	String PROD_AREA_LIST[]		= {"FAB1","FAB2","FAB1&FAB2"};
	int PRIORITY_LIST[]			= {1,2,3};
	
	// the amount of prod area, priority
	int NUM_OF_PROD_AREA		= 3;
	int NUM_OF_PRIORITY			= 3;
	
	// finished recipe chart size
	int CHART_WIDTH			= 600;
	int CHART_HEIGHT		= 300;
	
	// chart record column name
	String CHART_PRIO_DB		= "PRIORITY";
	String CHART_PROD_AREA_DB	= "PROD_AREA";
	String CHART_FACTOR_LIST_DB	= "FACTOR_LIST";
	
	// index of every chart values from chart record
	int X_PLAN_INDEX_DB		= 0;
	int X_RW_INDEX_DB		= 1;
	int X_RWH_INDEX_DB		= 2;
	int FX_PLAN_INDEX_DB	= 3;
	int FX_RW_INDEX_DB		= 4;
	int FX_RWH_INDEX_DB		= 5;
	int MONTH_INDEX_DB		= 6;
	int YEAR_INDEX_DB		= 7;
	int COUNT_INDEX_DB		= 8;
	
	// the amount of labels which will be presented at the X-Axis
	int NUM_OF_TIME_POINT 	= 13;
	
	// parameter for getting chart 
	
	String FNSH_RECP_CHART_LIST = "FNSH_RECP_CHART_LIST";
	
	int NUM_OF_CHART_PER_ROW	= 3;
	
	// chart info
	String PRIORITY_TITLE		= "PRIO";
	String COUNT_RECIPE_STRING	= "Number of Recipes : "; 
	String Y_AXIS_TITLE			= "X-Factor";
	// caching key
	String LOCATION_CACHE_KEY	= "com.bosch.in.location";
	String STAGE_CACHE_KEY		= "com.bosch.in.stage";
	String EQPTYPE_CACHE_KEY	= "com.bosch.in.eqptype";
	
	//String for empty EQPTYPE
	String EMPTY_EQP_TYPE_STRING		= "None";
	String EMPTY_EQP_TYPE_VALUE			= " ";
}
